<?php
/**
 * Intreface DAO
 *
 * @author: http://phpdao.com
 * @date: 2015-05-26 14:36
 */
interface JobsDAO{

	/**
	 * Get Domain object by primry key
	 *
	 * @param String $id primary key
	 * @Return Jobs 
	 */
	public function load($id);

	/**
	 * Get all records from table
	 */
	public function queryAll();
	
	/**
	 * Get all records from table ordered by field
	 * @Param $orderColumn column name
	 */
	public function queryAllOrderBy($orderColumn);
	
	/**
 	 * Delete record from table
 	 * @param job primary key
 	 */
	public function delete($id);
	
	/**
 	 * Insert record to table
 	 *
 	 * @param Jobs job
 	 */
	public function insert($job);
	
	/**
 	 * Update record in table
 	 *
 	 * @param Jobs job
 	 */
	public function update($job);	

	/**
	 * Delete all rows
	 */
	public function clean();

	public function queryByCompanyName($value);

	public function queryByDescription($value);

	public function queryByLogo($value);

	public function queryByType($value);

	public function queryByPay($value);

	public function queryByJobLocation($value);

	public function queryByTelephone($value);

	public function queryByVisaType($value);

	public function queryByAddress($value);

	public function queryByEmail($value);

	public function queryByStartDate($value);

	public function queryByEndDate($value);

	public function queryByWeb($value);

	public function queryByCreatedBy($value);

	public function queryByCreateDate($value);

	public function queryByUpdatedBy($value);

	public function queryByUpdatedDate($value);

	public function queryByStatus($value);


	public function deleteByCompanyName($value);

	public function deleteByDescription($value);

	public function deleteByLogo($value);

	public function deleteByType($value);

	public function deleteByPay($value);

	public function deleteByJobLocation($value);

	public function deleteByTelephone($value);

	public function deleteByVisaType($value);

	public function deleteByAddress($value);

	public function deleteByEmail($value);

	public function deleteByStartDate($value);

	public function deleteByEndDate($value);

	public function deleteByWeb($value);

	public function deleteByCreatedBy($value);

	public function deleteByCreateDate($value);

	public function deleteByUpdatedBy($value);

	public function deleteByUpdatedDate($value);

	public function deleteByStatus($value);


}
?>